﻿using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class ManageCenter_applyHistoryHTML : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string id = Request["id"];
        SqlDataReader dr =  SearchapplyHistory(id);
        if(dr.Read())
             HTML =dr["html"].ToString();
         HTML = Server.HtmlDecode(HTML);
        
    }
    public String HTML;
    public SqlDataReader SearchapplyHistory(string id)
    {
        string cmdtext = @"SELECT *, [apply_noid]
      ,[EditYearMonth]
      ,[html]
      ,[AddTime]
      ,[EditTime]
  FROM [Housing].[dbo].[applyHistoryHTML]  where id=  "+id;
        SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, cmdtext);
        return dr;
    }
}
